package nc.ui.budget.otherdealdetail;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

public class chk {

	public static void ddqwe() throws IOException {
		ArrayList<ArrayList<String>> bigList =new ArrayList<ArrayList<String>>();
		ArrayList<String> list=new ArrayList<String>();
		SimpleDateFormat format = new SimpleDateFormat("hh:mm:ss");
		System.out.println(format.format(new Date()));
		BufferedReader in = new BufferedReader(new FileReader(
				"C:\\Users\\Baliure\\Desktop\\hjs_fee.txt"));
		String temp=null;
		list.add("truncate table hjs_fee");
		while ( (temp = in.readLine()) != null) { 
String DETAIL=null;
String DT=null;
String CONCODE=null; 
String MONEY1=null;
String MONEY2 =null;
String PPL=null;
list.add(String.format("insert into hjs_fee(CONCODE,MONEY1,MONEY2)values('%1$s','%2$s','%3$s')", CONCODE,MONEY1,MONEY2));
			if (list.size()==2000) {
				bigList.add(list);
				list=new ArrayList<String>();
			}
		}
		if (list.size()>0) {
			bigList.add(list);			
		}
		System.out.println(format.format(new Date()));
	}
}

